Re: PL/PgSQL Create/Drop Table Issue - Mailing list pgsql-bugs

From Ian Barwick
Subject Re: PL/PgSQL Create/Drop Table Issue
Date
Msg-id 200305151815.54787.Ian Barwick <>
Whole thread Raw
In response to PL/PgSQL Create/Drop Table Issue  (Database Administrator <dba@vilaj.com>)
List pgsql-bugs
On Friday 09 May 2003 16:26, Database Administrator wrote:
> I believe I've found a problem in creating and dropping tables within
> PL/PgSQL functions. If you create a table, do some work with it, then
> drop it from within a PL/PgSQL function, it will work correctly the
> first time through. On subsequent executions of the function, however,
> attempting to insert data into the table will result in an error. The
> error report follows as does a script which demonstrates the issue clearly.

See:
http://www.postgresql.org/docs/faqs/FAQ.html#4.26

Ian Barwick
barwick@gmx.net

pgsql-bugs by date:

Previous
From: Dana Burd
Date:
Subject: to_char function has Daylight Savings Bug
Next
From: Tom Lane
Date:
Subject: Re: segfault in postmaster (pg 7.3.2 & FreeBSD)